SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039573 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039573 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264893,638998,877026,41579,889817,46110,130630,273599,426962,996333,489865,1024760,880956,130406,543086,996318,903182,469718,845840,170293,641955,379773,496347,33545,580340,441913,882504,245004,60290,826856,899597,432802,733925,669274,908419,820606,926196,1014251,171195,804970,609535,151805,15017,203588,322666,434564,947314,143985,516353,813043,546854,192235,657730,857515,606642,72756,448178,694729,591645,41391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]