SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433857 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433857 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615381,158053,138474,1047891,840031,593997,291991,72652,386444,546584,609721,303970,772809,327303,217729,431881,215724,631818,583404,885491,911032,81602,540579,678941,538164,732129,622179,522971,851897,484871,971187,732224,965420,866722,878054,745997,283237,142012,889229,317540,275905,457064,581173,324610,643873,631868,321636,923761,299801,614120,283028,826026,635519,68678,296380,444923,61750,505634,116102,715272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]