SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494325 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494325 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40047,105452,733577,300054,762562,548952,47786,898132,683053,944740,946326,1019278,49347,200155,988349,678047,378316,377235,504039,768987,145648,571731,439460,977201,831680,771486,144753,163438,925374,595259,676693,794225,881232,1028161,457864,947680,872199,472121,159396,965010,367714,994528,853644,284005,780927,874883,292043,682159,405992,548010,255552,452880,167191,39400,957137,934796,759800,4429,892733,635932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]