SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022033 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022033 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63964,539766,134339,588125,867081,165256,267376,958097,91704,872028,631541,742637,488089,665810,392847,153461,990944,517698,685988,365390,299378,76497,815021,660763,327110,762982,687935,447964,356868,1030855,592546,761528,371888,512768,884491,669068,805541,828177,160054,27208,833799,589704,18906,243203,588290,632930,269196,963156,925405,730493,901563,512399,106904,641912,84418,185466,803884,565989,972373,920110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]