SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631218 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631218 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116821,404802,491551,775623,20302,353676,438420,988917,481546,819186,354777,1018983,309659,1026613,873200,180714,616604,1010996,320822,490202,522053,502168,643370,824794,775372,709478,942938,641651,144829,764725,986149,790750,495601,998095,740778,754136,336727,1023401,465182,761695,343372,847958,163365,428988,450109,291576,822074,449085,36389,970521,510711,764856,811476,869682,935164,724548,377804,851758,709683,316484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]