SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002648s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524320 LIMIT 1 [ RunTime:0.001259s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524320 [ RunTime:0.002719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027914,1027780,801073,91732,166474,242611,633855,983012,175387,626348,503665,283802,465024,1029694,817492,868317,329545,893934,404696,736355,877937,119508,946059,1003289,13526,127046,587970,657909,594662,468521,1016867,150927,233229,855970,120653,505746,731589,27861,81679,723505,650886,421269,583649,15760,688789,804307,800874,178496,917557,564767,53898,388923,730051,438153,563409,955072,390931,618107,847441,602999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]