SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004941s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010219 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010219 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761196,1042892,645671,285125,802439,633891,211242,463716,205730,390172,799068,155826,986320,3340,82240,1013346,340112,746059,1035488,454510,425809,1038640,567775,497792,42543,563681,84535,474618,424232,354056,313354,667340,800466,74331,579417,898403,296406,767911,868853,401699,73533,544204,479211,775348,878424,163368,465656,709562,230418,795881,169264,625148,377147,397847,319289,636229,892095,81183,250296,379623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]