SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045485 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045485 [ RunTime:0.002299s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201001,280566,959122,655968,668125,784148,41612,540731,901571,839196,815670,535420,783265,100284,539431,759066,838863,571513,608697,964136,804539,298214,546100,722358,102940,752821,251530,53803,730112,201305,831618,810665,959200,717774,119505,306987,599765,838289,593646,602626,600962,694643,893585,340952,763570,816044,430654,580127,191493,689698,110719,214279,871608,658165,596746,806864,329392,945930,310035,913920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045485 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045485 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]