SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556506 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556506 [ RunTime:0.003037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455626,1000732,558744,300095,47172,860832,555905,70035,309234,195392,1035133,605893,218368,860414,258582,59198,181761,376967,584505,888577,387440,578642,890955,471838,725888,411041,808099,281594,91449,794911,792089,633042,285509,836510,404547,730129,711821,230991,619789,1007162,160449,769107,537311,540668,404454,586960,98327,246932,541911,588603,391722,222031,920720,119805,29341,105753,710919,355595,774700,227421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]