SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291153 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291153 [ RunTime:0.003152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013736,624308,120396,991045,934725,502287,423002,773277,802052,951672,1045231,404044,410469,738446,589661,977397,338733,6922,1043162,580290,617621,156810,21870,1029348,798439,902287,537484,736387,710983,498817,849176,507728,231791,144397,397494,336248,824078,924637,22236,101612,167671,348760,624461,771911,892720,389425,231847,642809,465468,333705,165341,433409,550340,984536,412424,305748,396196,995057,342440,273212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]