SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009270 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009270 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283153,863808,544555,406322,975638,283448,513929,332764,81145,627192,735228,6228,63187,435261,297369,55846,285102,410167,617964,1010883,271639,592823,226280,371282,735859,236507,716464,948001,492487,937436,991183,35993,622749,201960,353053,589585,849832,282076,115841,404466,764336,479785,943944,778938,128875,238323,796163,973440,923395,522034,611763,311965,935099,670622,263542,224961,992145,246745,936454,69337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]