SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041864 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041864 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983497,515946,8191,197187,240900,877479,640857,104327,309184,722174,44915,351992,451263,938713,41234,28989,461116,52281,110475,126119,293330,44173,689328,447241,373945,578010,217581,812693,396416,887537,532236,1031716,534431,642604,703892,43235,520772,586742,148644,13399,581776,900532,708167,491986,906823,966903,891234,507904,460608,399764,218406,179287,522637,549767,293564,366680,304809,474107,596285,804650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]