SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322743 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322743 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536292,1029800,354304,625529,908330,664942,231354,480056,752853,550040,657842,366315,425097,258062,985429,886264,564461,651109,287951,998630,803351,471709,485250,973560,13864,50185,25715,395362,1029588,391934,258990,81509,364232,614118,300297,385482,252314,305533,198500,929614,738139,850700,854512,591896,51264,270853,231226,197527,381646,839734,817002,105575,321988,798829,324588,579062,718493,713901,243830,870560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]