SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331003 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331003 [ RunTime:0.002794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48987,179438,217294,807626,691936,852082,935666,111786,596226,852951,375380,685562,344196,894229,652534,523541,253470,1028959,217819,525608,423425,198032,987071,956780,997606,480528,94627,644954,834489,562874,903922,796229,742683,834683,216522,695335,849490,796199,320284,29417,928956,84124,806135,87048,1020728,821762,719321,382666,226900,1005175,127682,865366,465251,165180,125428,614736,57742,645293,576560,1007050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]