SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535545 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535545 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779216,633264,944685,31414,773371,116019,838747,967830,195480,135245,392903,487228,593362,475911,346996,821755,539597,133466,105742,900908,232569,866942,910072,723405,228548,62761,115607,913638,397624,870088,725199,412759,669219,870825,796095,521990,416857,615594,160294,144092,211524,240062,218970,159207,123441,577868,694730,48868,1000876,630047,863849,955691,824795,781677,455270,1017364,196090,651602,91690,83207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]