SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431407 LIMIT 1 [ RunTime:0.000850s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431407 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291340,371124,276167,341869,39301,360894,291425,362237,97139,332479,652520,913187,885209,879140,364944,700933,249706,676119,783488,214477,495912,31123,318763,196527,271317,575484,510118,311664,272624,858729,837773,910808,589531,1025970,296667,159719,633500,155358,414306,247638,690730,385342,679505,318828,860496,233247,173408,284089,211096,394541,295615,311355,265663,668780,484406,182771,592071,435581,890870,408319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]