SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184678 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184678 [ RunTime:0.002206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786506,157938,694534,306294,906085,1015634,759824,723322,657775,79314,174110,152337,737288,69358,894234,871457,678493,623271,760832,340808,635835,913895,468113,900493,301945,248419,453888,757465,312053,1017577,805382,685598,440521,282156,187554,561271,425476,136568,397187,198111,977114,869301,763990,1035043,229889,650576,314460,575861,179736,544872,577894,366220,251224,359063,512800,901840,805165,897252,566423,808927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]