SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3104 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3104 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177414,293909,519383,287851,480803,33807,481138,862335,911543,620241,309300,827918,89909,701351,703089,168755,242391,825218,1015323,971,71570,866713,672677,34275,975440,795009,1019368,241855,786390,792888,417796,7415,716434,717940,508202,69032,194535,342219,1000028,911990,808187,726467,447080,521666,956609,663540,154533,862330,275033,353180,680211,5087,931796,964666,379174,944558,665809,515195,180224,348738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]