SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40305 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40305 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106534,432293,904065,765178,486508,100272,629107,501230,92503,976648,230569,231855,821465,1038546,817937,873330,693110,913640,798157,861917,88310,290697,409712,319701,408996,157241,842321,231454,100577,1003407,568805,960155,498195,685162,438437,831651,250278,563659,281141,901783,449191,417149,41394,336157,624927,982162,680038,415233,318717,925622,481758,292469,50888,716793,673714,210266,1021813,479423,493844,171992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]