SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436851 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436851 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326533,751718,51334,236754,1032498,15522,474049,420976,464957,182351,535070,179222,257929,466111,763822,112495,684545,863378,503704,435715,782648,654201,674258,164532,216949,54047,209187,262209,846861,551117,86940,225527,718995,402719,243111,19551,607045,338474,1045632,300062,529774,569387,755901,374316,329584,726187,297736,363123,152177,802955,652009,967177,257893,76651,275606,271555,453115,1045732,377219,329783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]