SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554975 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554975 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102668,111744,418097,1037525,977727,877302,959500,293865,23695,366862,107287,484272,884493,587201,697742,786163,551019,233014,477088,695792,438988,550474,741739,210933,4915,719172,530471,219202,474673,451309,696065,902018,845940,361776,207381,255843,645182,647401,685891,1025194,1047003,171155,345041,553309,173931,157862,491205,851841,664391,736534,928627,275185,405597,593276,320556,676393,573907,833342,271752,506913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]