SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 616817 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 616817 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008731,210469,252464,86962,941219,887170,122439,928194,695144,994577,288234,2403,485854,555345,669908,629893,129196,1036316,636983,899600,843999,1003348,710817,26462,868723,999433,457746,810190,305796,381492,360763,997501,701819,134932,307124,130574,66424,565259,716865,475018,247678,349639,604470,1029764,546447,248790,473141,647843,730842,213996,777217,510228,59663,873605,61947,223069,395881,131160,953950,839703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 616817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 616817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]