SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540985 LIMIT 1 [ RunTime:0.005611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540985 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624779,1019935,638867,323961,236306,222624,69396,714293,1027808,281024,759664,52132,742283,890272,136887,104404,96468,849657,449157,730607,139594,956709,988157,713866,759698,244840,677762,330137,611991,529091,318141,640815,187466,534263,545537,477990,711771,808578,762905,300202,196033,608137,782666,393880,1010747,840278,849925,948357,695312,62386,399738,132550,525821,205686,757323,688809,823105,956951,819221,974892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]