SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423398 LIMIT 1 [ RunTime:0.001259s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423398 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799025,740753,770061,462683,225494,200940,673307,1004715,185271,979801,942069,593131,226171,673875,107126,113921,956277,476448,235324,697368,198672,727283,933917,969515,282446,709160,152810,865516,437151,437549,919142,902002,766306,432237,180947,655400,1016896,40201,256544,438173,417675,279444,315453,776125,988599,604136,874886,854975,716526,1019230,659003,211595,200620,363745,962395,954565,164873,902291,242079,745369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]