SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000562 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000562 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498533,212578,11543,473234,632327,335049,719793,160783,155628,1026461,20354,598713,869475,718820,771012,964155,152585,747959,314032,1005099,435766,631179,876491,51673,331933,658877,171998,708894,348224,551475,293899,270820,111626,238768,362428,606576,793873,901570,129075,481431,191691,489721,184106,820651,30688,470440,488542,453204,873131,960902,491149,200475,94312,543588,1044889,755640,438029,207173,378263,454308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000562 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000562 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]