SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920094 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920094 [ RunTime:0.003009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174433,35000,312236,807503,783611,639972,565867,381892,764856,339888,111378,354389,60971,1044606,828581,119178,961795,830015,639087,771796,291535,250295,376379,100583,879286,380942,107573,411440,769012,741881,379880,167225,1008551,438641,260270,367590,9762,701788,768997,231303,177415,129509,717396,1003796,840919,79042,17733,183099,989102,680968,631514,356977,1026508,360251,827358,479744,11087,598213,377010,11929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001043s ]