SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423611 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423611 [ RunTime:0.003049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281358,505977,528894,788355,359738,106021,231277,501284,973128,1025012,301504,883380,943192,298038,730456,355235,102972,446957,685096,876373,210307,827110,565905,1028197,782709,1002664,853117,305930,809437,11782,269659,390145,582878,458247,187402,56032,667838,124188,1014705,280649,971274,699653,73147,443820,510173,815999,233571,9858,176977,862011,449976,990276,266633,855368,253973,469064,155334,916387,604788,21517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]