SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501497 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501497 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802823,318033,1004675,73048,15378,954804,423970,375893,1023171,577605,836101,151449,726661,362050,575233,826989,657014,554430,200361,232577,4796,571070,186128,164985,1026475,924063,993517,1002283,856697,95469,911680,401445,192908,515673,85287,744558,1030998,219124,355555,695133,74936,223119,916304,833696,107970,686169,118153,835959,898210,754197,294329,717070,945365,908131,282599,689441,824394,249899,295287,830148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002319s ]