SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534982 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534982 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037540,145173,1017376,449669,243115,558978,603370,324802,437126,335797,283154,131415,374972,596688,644597,939841,906694,366706,479781,625092,321974,66553,242481,55764,664671,114207,473354,99370,588045,545935,213841,208205,398614,41404,1038202,289697,569286,814938,620456,897366,76642,945718,278423,387784,316558,505542,97684,82996,302609,482935,825593,448430,839548,257099,751381,466443,346084,538362,241247,449912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]