SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019646 LIMIT 1 [ RunTime:0.002219s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019646 [ RunTime:0.006068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166619,920103,636585,215140,4612,970732,13522,983201,122134,839927,388365,627179,564249,454349,546159,482015,1039916,463826,570424,548921,482980,502093,593134,324838,728916,260556,954323,269557,519243,859850,163251,481096,133443,810404,68236,208061,1037984,898079,193613,2254,516441,271939,97337,770064,62609,981841,818301,243914,967077,542954,288341,241539,723053,972792,174365,943311,81085,734593,78245,327304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001442s ]