SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175398 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175398 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729943,869858,802022,966785,54115,541085,36732,607480,717698,872662,701209,52454,132200,604238,834338,45927,852702,465156,295277,63976,624767,844631,112657,518779,958855,392367,776749,876551,688135,379619,927304,822370,1048369,949819,613194,440415,1043971,95269,248358,229,144752,551021,32076,31715,524436,94917,843460,758893,83412,909471,219198,1020018,445051,700205,898874,1024743,361244,321031,467650,1030685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]