SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472006 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472006 [ RunTime:0.002230s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728035,132431,314968,190038,446834,286318,217123,520549,1038189,345844,585705,521357,816645,489429,387453,202892,383351,862150,1012354,624150,498668,346651,267527,423742,875459,681063,1028782,639331,256931,417013,555243,264918,261043,293151,556077,978110,653508,592630,347642,646986,377405,202902,524960,413822,185354,989035,189188,828376,187732,997449,202785,1017521,132962,363748,198964,745717,802181,1005064,323061,418710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004914s ]