SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537535 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537535 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923737,509348,124781,749194,404565,353519,780278,560888,73278,77347,368580,1016117,449713,180220,921444,386353,325113,321313,153712,541832,508907,1011358,78763,420820,598935,196825,280324,519807,114949,744050,209635,726093,61143,448159,778077,369073,692913,746083,1004132,402920,741257,913799,565335,365875,20057,206528,90302,1041825,340076,623899,287022,606487,279144,313197,764738,356046,116994,438261,17240,840745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]