SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514790 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514790 [ RunTime:0.003103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271488,110654,385985,1003670,489139,984306,462976,882076,536980,608023,710007,305689,920065,310387,281101,176268,929878,809691,168100,1013029,40419,691582,399515,276038,2493,131825,371367,886205,1040356,547867,309045,675109,617880,246732,270356,537978,198681,45236,61108,470885,6949,194841,1035554,633253,950028,808391,580215,805890,490173,351671,467387,106941,434189,547338,808573,628876,2679,792915,265043,172299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000753s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001763s ]