SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367840 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367840 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181918,598121,853356,63332,673854,1012007,429512,993009,205612,976547,1018541,1024298,320319,94887,259867,524403,137474,166017,43191,914067,663623,287371,636817,136938,279337,486123,551534,1043620,598963,892402,562901,198498,734900,22311,71496,612303,951589,969080,787027,472938,513785,844657,154533,378503,112409,155346,319393,671787,482141,581540,848043,227175,269184,220342,965835,87355,183029,659751,712702,491469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]