SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418291 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418291 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540489,386675,360582,688451,911441,835636,543155,849938,35406,544051,862665,820231,909509,417268,408157,309734,817200,422030,985069,883451,480179,29540,588341,923728,110510,7343,243584,776545,228561,1007755,640111,630256,182648,703722,999611,538238,228434,597768,453283,603992,638342,806450,811724,790938,55499,688440,953475,378628,290467,1026111,433694,579859,277017,428367,629476,920916,78966,873482,423933,202084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]