SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68772 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68772 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991107,905749,525032,215682,71901,205211,12188,216365,495425,434274,285508,670797,971708,158162,787200,809172,308062,790338,28820,69080,509017,948381,623416,200791,620705,980640,878879,635825,636270,582103,403954,490750,558370,61199,341221,579147,642409,69827,401083,411530,1034141,985028,876843,192188,1016338,398980,1007209,948278,13530,502923,1000417,734744,13226,1931,721552,755457,69842,617610,816244,533828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68772 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68772 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]