SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407590 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407590 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846449,250846,148288,782456,472892,650654,576976,133197,924321,251676,145437,220429,1022548,220832,404255,294692,129259,106274,639418,821522,404457,733455,455004,1018448,723868,224882,584991,1042562,269062,477386,1025959,693104,413918,628756,699013,1032108,700035,120984,155164,224926,1022008,163121,192581,969276,109384,346139,709842,619189,615543,505244,899005,597476,693445,1018746,938605,331954,557225,993867,716891,303761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]