SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519003 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519003 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176947,980381,248847,868721,310009,667241,415161,172427,1010209,195788,936262,90782,167304,261793,525000,565172,445794,55350,814506,37653,599971,143650,128234,916406,392335,287371,537836,403134,286997,599935,857355,807174,489370,474212,430077,785491,104215,118720,303111,457616,740197,416847,357106,56681,162094,329136,556632,352412,16129,878190,676191,58695,580849,827381,242542,830419,261134,415698,309202,547238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]