SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5701 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5701 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544452,39704,625505,313564,397057,805373,650511,318160,116343,776188,56117,558808,229964,86926,162011,1001223,598655,712242,254901,724915,955223,934614,446481,141826,388960,115113,343872,876838,629089,832498,581224,798953,1026902,863691,766935,558852,681555,410568,415293,127145,785698,359197,600622,357999,558553,601471,816381,1020929,803387,611573,925946,205919,390986,135984,159531,36976,723353,59885,977805,31611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]