SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019510 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019510 [ RunTime:0.003268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77798,650659,322819,985735,981729,648913,281566,519470,525071,755215,1028143,1001855,912483,667617,354495,143361,852105,290923,478351,251149,970971,729220,941729,356341,540723,848500,182449,1008416,746939,221670,209122,182956,556737,752981,308899,549144,535792,687993,975854,797694,268029,435519,480676,440540,795060,998755,452125,894497,135661,260733,7216,992676,315994,4126,493476,164273,133462,924803,128874,517940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]