SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 912603 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 912603 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82833,930115,568474,1012507,589678,716184,210719,38506,530043,194079,701366,104341,679548,1005259,797797,908655,967577,302723,540264,357523,958701,164782,307253,968173,706871,309507,1018657,779645,460775,305915,892352,693131,472718,109116,101611,404347,978472,314574,51110,913252,377105,336787,821653,582579,237988,103012,814346,355078,61492,1000828,1044938,819378,228900,896355,558158,887229,553562,276577,939333,245104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 912603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 912603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]