SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201054 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201054 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978762,462086,572190,1041437,334707,171442,608893,932230,37549,558590,1017878,80888,577524,430715,800702,28336,821331,262855,773398,884350,192634,767380,818665,811530,912501,735074,374676,1012709,466891,3368,435764,890594,1047603,309767,428885,566450,217329,467556,926811,441415,787627,556623,583141,495350,395733,357275,573035,96768,436934,540585,912393,156244,872025,524911,300521,217965,544338,271096,51777,236812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]