SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502204 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502204 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94132,957883,36926,195479,622662,988880,64467,515374,866025,799921,772822,191669,533558,210318,884186,536949,390659,1019856,780422,870986,795434,916182,755435,798168,452662,393593,513203,434913,519275,805472,883516,698749,308249,671319,298594,721521,306264,471343,729620,980082,971157,909090,649985,322190,428982,455814,866193,243502,143877,302717,599537,602632,346762,951356,220920,422836,95196,112468,532778,370890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]