SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451423 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451423 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847244,602538,105153,64785,627225,420285,143614,521664,373275,624565,309821,553149,64027,114949,1039062,319882,550701,345920,378888,656683,997086,331466,13459,219034,157770,866161,637611,667377,292230,656769,551208,388028,727695,810707,890181,460542,369788,490390,878112,370386,5149,39664,263422,404110,931533,405636,877678,801286,903490,800062,670443,902580,632682,429380,72243,808944,696274,406685,698333,235929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]