SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154680 LIMIT 1 [ RunTime:0.004371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154680 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631593,196383,601294,1030875,620378,198466,709116,441276,203970,537529,865293,477011,200404,395534,472544,714930,548181,622568,333371,372671,72396,440302,571127,584340,247750,760229,565984,489021,253268,509055,776689,479723,466786,979179,805755,959075,1018800,1000585,805441,1028419,492082,731007,855181,691977,103571,592004,974317,548393,640651,17843,776607,106616,140789,683273,127234,858014,291629,706205,509462,814859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]