SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430473 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430473 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214959,784744,305715,164670,216181,113972,883992,363494,514984,606692,936082,241365,230206,505749,447448,941808,537697,152241,103056,545354,821447,115488,282835,755667,1016724,170538,914416,672529,295799,789511,673000,340424,456970,468351,605114,629193,200899,641000,566542,907249,66195,639034,650731,589623,364902,945894,309466,489881,1048837,523979,372623,11917,783880,432067,815033,573963,529880,964592,643398,477020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]