SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502828 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502828 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972776,883664,569541,24728,433238,854602,993085,612679,647074,360580,479316,272858,312967,862232,372671,817660,1021087,660851,589240,965183,531453,763048,208917,61345,595629,462053,966409,112183,506514,215522,159149,999083,262878,101720,638764,446635,676219,634514,1004488,973067,260559,440686,1021288,783278,321311,695203,387791,532177,866525,417919,687471,463041,146370,884683,845514,313218,855237,572793,263755,496681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008468s ]