SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540574 LIMIT 1 [ RunTime:0.000624s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540574 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139882,286091,970757,891413,831146,581926,994054,227261,1709,363840,50810,99316,1025325,488831,124529,355911,146150,572869,829364,155599,361488,330945,497512,566818,314829,1025490,32275,35359,892048,288753,933389,334791,315119,535685,76680,846492,947824,283690,505273,235855,560671,41383,244477,878088,753281,968341,154258,186677,959523,837568,1016778,343519,616453,22088,1005500,186486,651127,951438,840925,1038128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]