SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368585 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368585 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420924,480375,179413,884266,1030593,446310,846689,510584,248938,520134,836442,482754,981505,487706,528481,266133,424489,468585,987862,864768,124399,1035177,910415,721445,580259,1045052,931443,772886,589370,985630,708130,274160,773343,453406,930062,675793,158601,947489,129459,226561,132653,124429,22919,7878,937497,509696,419520,788589,944264,660724,542407,521049,258109,572304,399535,355492,1039844,121049,897024,692896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]