SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287710 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287710 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028624,541537,848165,1036423,218857,318300,801309,367689,464875,929799,972542,13358,999836,760267,670950,163656,1025785,317923,499121,620585,104221,282090,2816,812504,431323,1020836,895095,649461,701594,775140,39849,997989,139360,948575,81074,565714,872327,301693,766456,7,1041292,332142,322514,397318,348374,1020283,831885,39045,536137,468998,13627,848109,954266,453481,195240,710247,147775,997627,936406,884454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000864s ]