SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802016 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802016 [ RunTime:0.002564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037009,338286,795437,251013,503562,434223,541658,300249,751771,317355,285200,971045,636449,739628,481625,187810,308738,398634,530389,942900,396421,786401,978821,562856,956546,904045,994805,506150,914793,5108,665184,83846,223577,86035,543032,887708,1016890,362152,377826,536028,478451,350617,878571,642212,141844,699009,650215,444508,680920,494217,89013,289267,128201,638154,7441,820484,200854,992488,417745,162684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]