SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335341 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335341 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510012,675650,972281,285781,1012292,240995,269844,879566,1007733,928166,115999,288482,22380,432011,1044854,255851,684113,822691,22046,558077,552251,920452,1025887,456906,796926,663669,111954,752019,1036604,543228,914522,1019310,943421,449533,122958,388735,1031045,423160,248715,839775,711320,634296,899250,563393,964637,326604,453239,403177,967857,394487,799481,460960,330085,307668,849296,322642,877097,980742,453227,542634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]