SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541051 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541051 [ RunTime:0.002994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511597,558915,461915,341530,5787,865132,986056,451558,849734,907511,878445,555105,998593,630242,204389,664270,193788,973299,912808,859005,208503,310440,334922,406043,743799,646229,428073,977461,92219,362414,404250,46167,365599,35310,228405,31797,346757,141161,618798,504576,613775,251886,109755,34356,817606,723893,701706,642839,935653,163721,254768,820610,182779,128848,315336,165665,16846,453042,351185,641832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]