SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529375 LIMIT 1 [ RunTime:0.001086s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529375 [ RunTime:0.002593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621064,109013,976897,370190,14132,505024,492208,173154,882719,585399,179084,372410,630510,179044,197259,794569,1002401,660373,507921,372793,1039922,751039,925777,598100,901882,368626,487020,85878,45952,494941,30904,447921,830254,104746,933508,898307,340633,347863,297880,141128,516235,886999,281768,402613,229081,582348,483895,489367,113553,799489,600732,883366,400353,776074,174742,338348,577372,288836,55300,72120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529375 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529375 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]