SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501705 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501705 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690994,729123,693024,422566,804526,938638,772806,1006588,787754,917116,410441,129819,961597,680087,644594,289966,675057,961310,539030,593051,387285,938800,746295,54749,430272,673221,896073,518788,314786,914194,346466,635402,885335,585781,110374,7876,682423,578005,798696,973909,169700,13659,873443,41480,859725,299910,772225,292933,368342,154357,989774,599506,117960,107201,800043,649404,643378,914642,295734,181316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001014s ]