SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514957 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514957 [ RunTime:0.002904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816526,98492,743908,359286,555675,841601,660509,560796,814561,290897,656846,533484,789142,855082,824690,770404,669833,127748,215419,570142,25642,741091,53038,764366,840108,548006,241357,607351,982116,434600,492913,360447,781039,242000,828499,503659,542989,68732,257782,473969,270152,375665,492758,374535,64043,577699,209578,317729,732783,766683,432552,845734,21950,712426,247694,705826,1038987,470467,588336,132612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]