SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001840s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320410 LIMIT 1 [ RunTime:0.000976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320410 [ RunTime:0.005195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337912,622507,862116,689190,944074,905423,159873,614047,697799,965998,258578,707825,403961,1042096,884413,439536,572885,211720,45546,133015,660254,636229,394723,174544,320567,611903,980132,170709,723299,57864,999941,359261,670340,806914,521441,656206,75579,201858,39667,742057,987095,569632,345231,736409,190077,26495,629442,1039557,267037,355853,985753,410123,592294,37892,189836,705639,910931,459956,854091,638594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]