SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810418 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810418 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963191,770831,303502,189175,615274,1047983,924502,75291,43943,1024318,1008905,176767,123195,348946,489821,628039,623471,261237,595164,950196,727470,631197,379003,974890,57303,574053,983620,685965,12434,133170,872807,187101,794432,45509,271064,480385,341434,487488,17865,690506,806116,1045747,504914,205877,332796,317639,367018,142880,404526,936114,12101,804184,367806,105668,736560,738430,337766,674026,719724,212697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]