SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000336 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000336 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743680,216083,203515,1041465,160307,984057,381603,195645,5444,633843,46459,96339,8351,232086,867920,258087,936771,546135,590641,389289,803967,242054,891784,908303,25047,466713,830233,473786,364844,847662,490737,193361,485706,73138,325695,449678,580188,388931,151031,1040721,363738,252668,999514,305391,505623,284514,885580,483653,341958,523918,503968,1034450,639641,308917,541183,222942,730942,727946,460255,463731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]